package com.example.dao.impl;

import com.example.dao.OrderItemDao;
import com.example.pojo.OrderItem;

import java.util.List;

public class OrderItemDaoImpl extends BaseDao implements OrderItemDao {

    @Override
    public int saveOrderItem(OrderItem orderItem) {
        String sql = "insert into t_order_item(`name`,`count`,`price`,`total_price`,`order_id`) values (?,?,?,?,?)";
        return update(sql, orderItem.getName(),orderItem.getCount(),orderItem.getPrice(),orderItem.getTotalPrice(),orderItem.getOrderId());
    }

    @Override
    public List<OrderItem> queryOrderItemsByOrderId(String orderId) {
        String sql = "SELECT `name`, `count` ,`price` ,`total_price` totalPrice  FROM t_order_item WHERE order_id = ?";

        return queryForList(OrderItem.class, sql, orderId);
    }
}
